Value2 Property

Returns or sets a Variant representing the cell value. Read/write.

expression   Required. An expression that returns a Range object.

Remarks

The only difference between this property and the Value property is that the Value2 property doesn�t use the Currency and Date data types. You can return values formatted with these data types as floating-point numbers by using the Double data type.

Example

This example illustrates the differences between the Value and the Value2 properties.

Sub Value_vs_Value2()
   Dim rngCell1
   Dim rngCell2

   ' Set a variable to the cells used in this example.
   Set rngCell1 = Spreadsheet1.ActiveSheet.Range("A1")
   Set rngCell2 = Spreadsheet1.ActiveSheet.Range("A2")

   ' Set the number formats used by the cells in this example.
   rngCell1.NumberFormat = "Currency"
   rngCell2.NumberFormat = "Short Date"

   ' Set the value of cell A1 to a currency value.
   rngCell1.Value = "$123.456789"

   ' Set the value of cell A2 to a date.
   rngCell2.Value = "9/7/1970"

	' Use the Value property to return the value of cell A1.
   MsgBox "Currency returned by the Value Property = " & _
          rngCell1.Value

   ' Use the Value2 property to return the value of cell A1.
   MsgBox "Currency returned by the Value2 Property = " & _
          rngCell1.Value2

   ' Use the Value property to return the value of cell A2.
   MsgBox "Date returned by the Value Property = " & _
          rngCell2.Value

   ' Use the Value2 property to return the value of cell A2.
   MsgBox "Date returned by the Value2 Property = " & _
          rngCell2.Value2
End Sub